﻿CREATE TABLE [dbo].[ServiceApplication] (
    [ServiceApplicationID]        UNIQUEIDENTIFIER NOT NULL,
    [DisplayName]                 VARCHAR (200)    NULL,
    [Name]                        VARCHAR (200)    NULL,
    [NeedsUpgrade]                BIT              NULL,
    [NeedsUpgradeIncludeChildren] BIT              NULL,
    [ServiceID]                   UNIQUEIDENTIFIER NULL,
    [Status]                      VARCHAR (200)    NULL,
    [TypeName]                    VARCHAR (200)    NULL,
    CONSTRAINT [PK_ServiceApplication] PRIMARY KEY CLUSTERED ([ServiceApplicationID] ASC),
    CONSTRAINT [FK_ServiceApplication_Service] FOREIGN KEY ([ServiceID]) REFERENCES [dbo].[Service] ([ServiceID])
);

